ExcelBanter - HELP!!!!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HELP!!!! (https://www.excelbanter.com/excel-discussion-misc-queries/75312-help.html)

nick

HELP!!!!

Hi,

I want to populate a default value ZBN in B1 if there is any value in A1
(any char). How do i do this????? Any help wld be appreciated. Thanx

Ron Coderre

HELP!!!!

Try something like this:

B1: =IF(LEN(A1)=1,"ZBN","")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"nick" wrote:

Hi,

I want to populate a default value ZBN in B1 if there is any value in A1
(any char). How do i do this????? Any help wld be appreciated. Thanx

nick

HELP!!!!

Thanx a lot...it helped.

"Ron Coderre" wrote:

Try something like this:

B1: =IF(LEN(A1)=1,"ZBN","")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"nick" wrote:

Hi,

I want to populate a default value ZBN in B1 if there is any value in A1
(any char). How do i do this????? Any help wld be appreciated. Thanx

All times are GMT +1. The time now is 10:24 PM.