🔒 Closed EXCEL question

[Destroyahh]

hello po, pano po kaya iauto input yung "pl" kada cells , like no need to input every "pl" text in every cell, like yung number nalang ang ilalagay kasi andun na yung "pl" sa cells , di ko sure if formatting or masking tawag dun, nag try na rin ako mag hanap sa YT at Google, kaso di ko mahanap yung exact solution or method, MARAMING SALAMAT PO SASAGOT❤

 

[Phc-Joshua]

eto paps, right click mo sa cell, tapos sa format, click mo custom format eto gamitin mo

0"pl"

 

[edpb]

ganito po ba..?

 

[Red Satan]

You need the concat formula to achieve that

 

[Destroyahh]

ganito po ba..?

hindi po, like nasa format na ng cell yung may "pl" na text , like yung cell eh parang blank pero pag mag tytype ka na mag kakaroon na ng cell

 

[Phc-Joshua]

hindi po, like nasa format na ng cell yung may "pl" na text , like yung cell eh parang blank pero pag mag tytype ka na mag kakaroon na ng cell

try mo yung comment ko, tignan mo

 

[Destroyahh]

try mo yung comment ko, tignan mo

ayaw naman boss

 

[Phc-Joshua]

View attachment 2142089ayaw naman boss

Panuorin mo to paps.

formula: @"pl"

pa-mark as solution nalang kung nakatulong

 

[ChuckY DolL]

You need the concat formula to achieve that

View attachment 2142084

agree

like this

 

[Destroyahh]

Panuorin mo to paps.

formula: @"pl"

View attachment 2142110
pa-mark as solution nalang kung nakatulong

thank you boss❤

 

[Phc-Joshua]

thank you boss❤

welcome paps.

yung CONCAT kasi need pa ng 2 cells. Diyan 1 cell lang.

 

[Destroyahh]

welcome paps.

yung CONCAT kasi need pa ng 2 cells. Diyan 1 cell lang.

indeed boss, salamat sa idea mo boss

 

[Phc-Joshua]

indeed boss, salamat sa idea mo boss

always welcome paps