Add string only if a text is present in a cell
Solved/Closed
Related:
- Add string only if a text is present in a cell
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add a checkmark in word - Guide
- Excel count occurrences of string in cell - Guide
- How to add a watermark to a document - Guide
- How to add at the rate in laptop - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
29 Jun 2015 à 14:05
29 Jun 2015 à 14:05
Deloro, Good afternoon.
Try to use :
=IF(B5<>"";CONCATENATE(MID(B5;1;1);".");"")
Is this what you want?
I hope it helps.
Try to use :
=IF(B5<>"";CONCATENATE(MID(B5;1;1);".");"")
Is this what you want?
I hope it helps.
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
30 Jun 2015 à 10:36
30 Jun 2015 à 10:36
Deloro, Good morning.
Please, open another post to present your new question.
Using a SOLVED post With another question, dificult people to help you.
Have a nice day.
Please, open another post to present your new question.
Using a SOLVED post With another question, dificult people to help you.
Have a nice day.
30 Jun 2015 à 03:19
30 Jun 2015 à 06:52
now i have his string:
=CONCATENATE(CONCATENATE(UPPER(A55));(CONCATENATE(UPPER(B55);" ";UPPER(C55))))
the fields contain names:
name 1 (A55), name 2 (B55) and surname (C55)
with name 1 and surname i have te result as: Name1 Surname
but with name 1 name 2 and surname i have this: Name1Name2 Surname
so i need a space between name 1 and name 2. how can i have a space after name 1 (or before name 2) only if name 2 is present? (i tried but it adds a double space if name 2 is not present..)
i can't figure out how to write it..
Thanks
30 Jun 2015 à 08:36
=CONCATENATE(CONCATENATE(UPPER(IF(D55<>"";CONCATENATE(UPPER(C55);" ");CONCATENATE(UPPER(C55))));IF(D55<>"";CONCATENATE(UPPER(D55);" ");" ");UPPER(E55)))